SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026569 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026569 [ RunTime:0.004510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (464552,240902,848335,901633,274759,337895,361998,141918,426249,696979,919657,623342,540374,136907,898612,784466,808593,841684,467347,678079,451815,1007979,331556,657677,502341,584787,276851,574036,342793,647040,933870,208319,516138,740141,1033370,476761,512899,622812,35572,504266,290,465731,326928,647989,582721,846223,745739,302734,34028,535863,811482,673778,406629,526920,156772,149892,576797,998479,106548,601659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026569 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026569 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]