SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414474 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414474 [ RunTime:0.002099s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (549033,698806,736106,140275,629459,277737,945351,1034516,321470,1040750,883539,516734,242386,211205,125581,658149,488189,80463,808365,891760,759045,284863,28097,121121,1036910,311679,843976,11372,216120,555223,116093,872967,26604,487199,863803,26596,713936,581127,559382,338838,877345,768348,206037,477197,337065,295307,352984,627268,623993,108681,391649,770094,455292,669503,975693,348010,965763,1008771,284249,239532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]