SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021572 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021572 [ RunTime:0.001526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (106167,551406,615623,162875,57296,122051,176911,456928,649801,45231,117262,316371,420448,851272,326821,560102,773433,825460,564511,303916,328569,50936,58353,127824,691107,1028248,733022,404879,761319,14452,467045,4635,524318,997540,48763,639512,699282,785583,778466,703067,962296,161705,239085,496043,666138,384465,378631,863896,201503,599750,820846,175157,815720,350533,676385,135645,96833,1024436,992358,485891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021572 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021572 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]