SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027353 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027353 [ RunTime:0.005921s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (45446,918235,596296,789491,800344,493425,135386,800141,175330,561145,988267,653900,50414,646585,141300,132193,674600,696306,988942,738744,659402,542310,319362,578818,873975,689175,65903,186074,669556,748200,328492,114107,460885,798074,817257,512959,1022489,593597,616403,52311,646677,588616,747241,731850,403646,33373,599041,200709,537976,422588,373143,597337,36497,562664,1018489,33661,721769,730084,63222,204983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027353 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000741s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027353 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]