SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198583 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198583 [ RunTime:0.001691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (574641,383329,167245,157659,590293,1013852,301549,980214,94569,804653,1020778,335089,51850,736287,481822,136596,176216,306487,748684,402274,723090,289887,537495,136347,583470,1045217,461525,886942,716091,403177,21431,1012979,607810,389722,796474,554565,56972,172017,718398,824809,1015285,621852,712789,518714,800239,241104,48274,876842,512824,569007,302066,287032,330732,145410,234651,1003698,705328,720426,65524,295036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]