SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 781028 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 781028 [ RunTime:0.001889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (538988,355416,361982,645816,107930,644732,401335,51124,450356,521913,459875,978541,116490,294459,268304,658301,661528,776740,427172,505717,205179,638100,570418,312632,18970,444042,387950,180344,310401,718122,994501,428252,791668,223671,91813,119704,898505,315650,60248,662258,553920,492136,314260,399633,265295,196010,466175,1016952,709641,106514,619957,17227,109213,853279,304161,571428,890814,956702,485781,691665) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 781028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 781028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]