SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475101 LIMIT 1 [ RunTime:0.000494s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475101 [ RunTime:0.001725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (157039,571794,283204,449172,69643,300932,555632,958506,315979,331774,251642,310411,856213,273501,858738,506391,997371,215204,896547,537428,132798,585584,508958,80330,27317,505195,237772,17700,102045,942561,647534,810718,880971,472784,609046,863634,117329,609950,159114,497805,285209,187944,1000608,511880,719651,951854,180070,126300,946501,109556,1036953,315443,637444,129123,603930,952746,141150,802387,841787,649330) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]