SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154096 LIMIT 1 [ RunTime:0.001729s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154096 [ RunTime:0.000990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140716,835767,694530,769665,590973,935698,112388,651340,251815,743720,369264,552093,726015,654627,510445,1012928,351572,282000,1032054,187465,1024486,109767,775590,967040,504747,958307,499622,236224,290473,764607,917101,281187,294769,338475,627724,893462,149067,357349,139049,683833,217227,824240,882436,300106,504530,752888,800743,1047979,53306,432147,209703,415797,1017771,482017,1032278,743500,188851,683558,65249,391614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003883s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]