SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 448233 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 448233 [ RunTime:0.001954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527311,591035,164932,915445,682860,370536,199495,105996,929655,508948,686562,114060,803840,909207,181714,384343,417130,1000880,346726,276413,710840,224309,991512,96970,661755,902029,54401,439490,691604,980880,279575,196678,607532,391330,73217,541643,911335,469182,31249,713095,758984,893002,880853,683857,326698,748986,569820,40501,1007973,946517,376274,33435,102326,395168,752389,715311,444061,616967,909479,1024549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 448233 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 448233 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]