SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047840 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047840 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555230,357211,605419,26345,359208,864248,270470,753226,52680,7021,259396,125270,395268,954822,94735,777157,974370,611430,939657,535768,638291,19177,68063,530546,506641,107932,399253,886408,339579,434570,313256,30292,127284,1034475,863663,292368,967788,485655,942992,430796,563317,687008,390399,762170,371933,821622,999404,1003664,780139,613894,1019108,779630,543036,133882,472067,838831,696954,250233,37291,815884) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]