SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001409s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516631 LIMIT 1 [ RunTime:0.001396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516631 [ RunTime:0.005656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (751989,458111,800303,618228,269290,663837,269697,819574,378700,399151,101575,992026,908144,653200,919526,666472,353293,134480,857092,952633,837695,852780,1037482,330436,305646,492026,287686,708278,212548,513458,546060,308828,423430,456648,394572,411489,794853,800891,579099,733959,640266,164023,404216,220476,997634,130021,400197,814572,76435,1027894,833084,8375,754393,917891,330369,961085,917293,72113,392437,185386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]