SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001580s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 599808 LIMIT 1 [ RunTime:0.000527s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 599808 [ RunTime:0.003484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (558170,7779,914423,71370,791862,195464,135966,782184,729685,427001,783233,695963,663327,586687,425374,178256,582922,664401,1003433,740852,694542,635522,255470,842867,763731,505276,348683,843071,74887,536490,136208,242002,98742,82643,22689,787718,751124,1005574,182290,203156,633511,508157,17825,49346,632001,175110,309855,708785,569084,768527,46527,241752,754441,743962,657413,54097,140196,160801,462412,813293) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 599808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 599808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]