SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003887s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028950 LIMIT 1 [ RunTime:0.003879s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028950 [ RunTime:0.004539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414783,324517,848848,93278,919307,759988,757679,438213,543108,769472,459025,98831,1015044,184701,412025,180345,238860,698152,511489,384643,280827,466025,795592,652113,242966,499553,21376,72302,169938,359603,755059,248808,210721,302346,989456,424560,77249,659778,691739,790343,948295,645392,723907,50332,606070,1003815,131409,324163,238374,606637,889262,317500,445851,158984,677270,191203,66268,925297,12566,118907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028950 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028950 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]