SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001550s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482582 LIMIT 1 [ RunTime:0.003347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482582 [ RunTime:0.003194s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501838,728357,218451,420613,1046557,187367,1007597,380473,895464,657179,393501,920273,952683,919742,683695,131626,225559,567651,125841,168849,1018463,194295,314350,715452,661633,31013,953473,672870,508527,862779,712232,738030,429192,124899,135494,1028430,627685,724079,896522,679027,605727,1015147,1030281,410775,765553,7716,717295,108387,624705,147383,694348,520599,764509,478254,84707,942289,991442,344445,514449,29845) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001547s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001020s ]