SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040078 LIMIT 1 [ RunTime:0.000278s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040078 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (951441,941027,259294,504541,532190,445143,830527,953318,306849,12521,53553,299642,479514,413603,786016,612453,184499,824653,615015,480246,920796,717680,554171,43460,200679,939499,919264,205893,885142,950252,1018359,464446,737275,795426,809701,1030656,396949,744549,798291,84769,818912,317969,410330,539632,404906,65513,316897,498532,584727,924290,267417,473284,782801,97786,661600,966448,403057,426964,132244,944235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000822s ]