SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002018s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319997 LIMIT 1 [ RunTime:0.001263s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319997 [ RunTime:0.003260s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (991576,133565,96589,780175,12324,991083,756352,503532,773364,995195,631880,665141,375805,1018163,937617,1023003,974311,373193,963708,1002670,588881,585427,367065,148999,103381,176351,91403,568373,216191,100807,928194,863713,312957,925097,196520,896891,607115,783914,1037788,666219,932231,951047,690253,687962,969358,283415,101613,947895,200330,297871,182762,48804,470543,83128,160345,852697,40018,386456,81220,552691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319997 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319997 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]