SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393916 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393916 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (725451,382356,218660,649118,477268,207779,512346,145758,376919,467297,680474,906958,495786,180868,159715,122004,122605,699098,668822,587633,854792,628102,492902,871741,1042936,390968,125830,1044739,251477,514170,382626,201287,403914,696875,279048,685232,266698,52647,346131,663807,713957,655301,1002105,409899,96624,394088,383312,142743,130620,536892,31438,258936,840403,662089,880908,568395,450223,961552,411284,868667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]