SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531050 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531050 [ RunTime:0.001673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151928,84826,1029942,763496,627446,625730,470973,622046,69229,874111,685402,890682,301314,431095,834721,32420,322981,145533,691638,715069,477047,85772,451525,837789,135388,149037,651193,363419,274198,814641,839674,758609,547402,844534,841437,240512,516743,994303,399588,42484,460321,829257,477233,7173,906175,300107,247636,581918,877873,159991,1036883,181343,221889,709247,744430,559951,338355,905469,336159,233568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531050 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531050 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]