SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543410 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543410 [ RunTime:0.001716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551995,946304,50143,46307,644582,1043726,146257,785966,205448,579400,870049,189976,1029822,568348,878034,945297,115998,488454,671975,407922,994408,969817,5950,799423,777673,235513,828269,718806,573021,804265,305272,284015,529779,689672,892211,861333,1001698,11037,694793,629392,784546,140480,120256,71872,391264,71755,5520,241039,43048,229361,395084,914237,606448,406977,581764,888158,423929,295357,614275,53003) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]