SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508450 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508450 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (974572,534288,195834,29972,91980,404071,43917,455448,108195,546174,992191,90359,182340,564632,247902,650081,497277,428909,179346,857711,295519,692439,14397,519982,1023552,405309,488826,772231,34090,203369,38027,869380,329594,379833,799363,994368,367976,586214,146397,448065,691798,54472,40846,804988,216738,825559,533330,339496,364777,60064,175679,77862,356158,196342,504854,802685,418466,683382,976866,210999) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]