SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 143411 LIMIT 1 [ RunTime:0.000547s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 143411 [ RunTime:0.001643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (681212,257926,265833,785315,294359,113633,425176,799401,487907,519719,517743,248145,740582,670861,396189,661988,769423,509954,984724,1034826,687029,725411,791906,678197,173430,15113,704196,181977,995178,400390,18934,23106,722640,543275,413698,763352,97526,379072,445265,345552,1048673,200490,600091,1040444,68443,526832,965010,144905,559520,462440,1015151,981735,8688,368837,626771,194210,689021,288923,1028223,195704) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 143411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 143411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]