SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528062 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528062 [ RunTime:0.002313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426510,630273,787209,502599,543288,350872,17100,876104,232170,717559,794461,795509,615247,255125,555569,789653,70661,804449,192718,923968,904743,81664,740108,67080,28285,987918,602978,698817,881573,85479,358985,49464,609718,419222,386121,749955,618363,796773,24346,31717,923935,679361,359544,970205,380124,734921,883451,877371,21529,504873,213192,823824,514105,153876,284857,927274,1021668,666765,11132,304076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528062 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528062 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]