SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200964 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200964 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728756,69031,748832,3545,344716,607984,400362,574643,632863,879159,474671,244988,283504,72922,143769,116511,1013650,864407,723191,851844,475505,174479,922907,706518,361918,43762,273158,531044,43731,495136,813330,174734,601933,905761,957333,1012696,545947,834926,137305,534550,962575,1036418,968191,381858,801282,425173,1003736,338862,917271,186795,155834,310125,892407,367104,198765,860641,786447,279546,57410,655848) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200964 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200964 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001503s ]