SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562854 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562854 [ RunTime:0.002146s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (847399,929482,412799,30108,77705,189456,147846,857948,212624,405699,734404,877065,823876,432830,949061,1030782,476642,71248,1030910,734707,411403,96578,796250,338598,877318,21349,196044,578691,653461,948388,61325,687325,745779,410848,341924,561994,812206,330051,18838,91175,409675,761511,170885,658311,198346,739833,688542,451202,872467,65476,783979,213737,319228,63147,632004,226039,794739,369083,483257,401396) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001738s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562854 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562854 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]