SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410781 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410781 [ RunTime:0.002451s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467571,974763,638762,940168,377349,763793,770176,251023,540535,678671,780883,254049,687997,680994,686015,392027,866127,1047195,151463,507725,323291,534185,802455,149983,636337,972437,506634,504880,157164,536475,234505,413396,1044617,5041,77155,554064,138820,286436,917889,80287,670011,678409,850128,450435,221769,75532,566203,954954,300815,882615,742086,640989,244213,886243,484871,43268,740300,298576,896868,592856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]