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` = 311260 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311260 [ RunTime:0.002341s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (999201,388393,128588,161917,26580,13470,613720,364610,54636,234972,514061,338390,333433,225573,186433,960967,113452,552292,894574,127138,855945,155498,879616,921575,770484,931802,108025,227115,895353,7082,278315,462047,988872,403034,627752,188146,759051,294482,89634,642,826337,259861,421510,844652,47189,793315,752082,120057,417390,858979,655756,1009574,189182,878568,317882,902268,946224,516231,396980,319543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311260 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311260 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]