SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424790 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424790 [ RunTime:0.004392s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111626,998581,997256,904302,3473,642702,92887,273682,207025,451966,418763,159424,672696,440163,509709,279134,415769,741919,977870,68538,567140,900078,490814,9831,502371,861864,1040687,358340,246307,624876,496162,788486,238603,806849,28679,598345,573259,75567,725429,434338,606227,305302,652391,921276,19633,544900,1007261,845496,615456,879182,39757,507845,752961,218041,10712,133482,843642,869489,856053,406213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424790 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424790 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]