SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104508 LIMIT 1 [ RunTime:0.000284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104508 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (862767,191877,643261,244661,588293,513971,412602,255319,1033228,890476,510447,504662,358376,1003076,454010,569583,1047162,45166,27329,86310,318330,257387,901190,20811,203183,532970,207541,589030,611745,842703,732108,398969,483400,328630,164225,56093,738542,397372,93423,976760,826176,476529,249323,315349,865868,365266,29123,341213,1025934,288536,848270,873141,109265,859940,495741,420679,587115,659477,307127,1018706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]