SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 364563 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 364563 [ RunTime:0.002396s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191864,474785,801000,607149,442798,994242,586175,881395,242164,373676,686735,910054,2606,348843,8975,203220,872478,93504,407100,877091,619891,463116,4503,440232,579427,584297,505147,800693,550687,212016,959274,149324,308429,497487,980943,659198,715478,633875,749223,499930,889686,398700,491705,622945,43157,188044,27716,59848,151656,139578,430896,830805,52236,287461,1006196,289739,671371,846838,245011,545412) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 364563 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 364563 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]