SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002026s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345728 LIMIT 1 [ RunTime:0.002694s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345728 [ RunTime:0.004029s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (158508,66311,665667,1000598,794621,707076,1022961,262659,301225,273691,4190,717203,31543,288419,209465,698290,225017,378385,447535,957161,335453,940321,131682,514850,735560,105434,992253,665887,996209,96425,33586,169783,792465,798947,977904,45928,315385,602562,162554,362240,893082,648714,248401,29222,740300,489407,223514,547159,244705,884554,776445,631078,239955,776975,677919,272724,550532,411249,141493,83457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003702s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]