SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001484s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470611 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470611 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654477,634034,380012,691378,834034,227422,176813,752860,730459,257015,497703,550041,193690,173747,294170,125012,524642,766263,16139,604769,309339,514622,162415,544632,159744,796957,104135,892516,461457,755975,661317,531114,93437,491755,804751,686784,1023244,746008,576790,78602,535474,563796,874772,244088,277268,529466,644979,852860,501810,822313,601648,965878,926447,641478,874311,75107,5439,527104,844369,143263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]