SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305970 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305970 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (649595,188205,451247,497823,650162,1020283,956504,289168,454300,882413,355973,252822,825761,367627,401942,982353,36744,753762,378792,142297,388339,1017379,690784,701637,78787,633236,138986,680899,984328,768449,112801,545822,912919,1030903,1035001,832376,489005,404861,490107,591057,46918,430533,149774,321302,365989,334839,907503,363053,397639,419414,658871,66910,496545,360303,576372,883842,623592,277379,957617,986673) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305970 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305970 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]