SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511868 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511868 [ RunTime:0.003787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048724,696808,200703,76029,124075,898329,734847,338224,681263,103219,593011,280819,791605,620076,977719,291468,51247,97755,75763,449311,173864,884828,245208,747492,489319,626632,198915,649375,621923,13706,398670,546224,173186,389592,740918,658508,776945,567934,770312,352045,159501,591872,327556,101638,601777,617724,815672,711246,736157,641912,73183,517170,595603,601298,811097,950286,898654,867884,553951,121848) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511868 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511868 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]