SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 25493 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 25493 [ RunTime:0.002565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281431,1034389,805484,182391,305530,919,770264,813344,882191,156481,338177,853342,728372,182620,953707,426733,392434,201774,303856,697490,595954,193635,229092,540206,453935,638076,624604,866362,918509,431556,809051,412344,541193,398779,236969,619076,990907,882051,526757,279398,670085,165310,192012,515305,132414,876460,79495,17249,247449,82320,520994,165744,106695,704036,601640,852475,375939,885989,1010169,761760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 25493 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 25493 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001404s ]