SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 742016 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 742016 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (770991,563230,398859,1006536,330494,908552,817402,851462,765190,88075,351157,981752,810917,552019,124648,746282,448245,584538,994542,895329,994754,418329,677552,480023,938616,960327,527965,31707,400089,715174,350570,445503,1021078,563988,771262,416466,680696,892549,189234,609177,165093,475063,851638,428282,922264,98261,865623,475036,343219,642272,495271,124255,668965,439268,710723,754887,2971,249921,217965,688126) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 742016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 742016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]