SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108708 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108708 [ RunTime:0.002381s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930031,996584,634928,402696,1020803,637289,67662,158276,691371,1004923,908840,1005737,563780,363517,257225,861031,205145,516617,1014682,772138,818555,886545,627264,107500,811752,463335,965081,346848,610165,629852,98298,969343,350698,26428,994581,125195,301112,937233,950618,282936,206127,793084,761819,1047208,705990,1033915,638183,59509,315246,138656,818199,637525,560841,703708,377598,252555,636568,911480,821099,632968) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]