SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338083 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338083 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (966828,825482,844107,805437,232833,39180,448519,227249,773954,354271,518386,588703,760273,104599,176179,161791,356772,543613,396374,819629,170466,230706,1042174,697725,67241,396003,922145,745440,1003024,791801,383340,35454,161295,329285,969178,338224,90817,487030,354401,15608,839707,316094,398073,1041828,424582,985111,413608,913440,100754,446294,658071,932575,857417,305029,767904,32386,707149,583591,680084,270874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000396s ]