SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391812 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391812 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542179,32333,772363,796963,740104,115576,633777,57959,51357,834425,375991,180917,462198,157321,392407,869041,254270,243480,295805,1002,583050,576689,444149,1046336,438441,89,954261,273046,296093,338957,280360,390947,96489,900988,863831,420618,850013,209897,849371,1030786,133699,787958,523844,761964,760041,971677,572601,421281,180384,667871,580195,237356,879004,621524,587604,1009855,987849,205670,537518,758272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002161s ]