SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003610s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555570 LIMIT 1 [ RunTime:0.003637s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555570 [ RunTime:0.003234s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (223428,173973,159280,569176,437234,780160,353637,532306,1036486,81639,304008,124853,829018,793842,958786,269766,746841,20360,435557,524739,8894,380746,237420,452859,12992,820304,851397,19883,749874,1003140,232563,12327,507391,726929,476504,197767,125381,1008178,719945,623536,761535,869003,880423,184083,472244,146962,826592,638292,879252,442690,85128,16132,623722,876881,667242,493633,165155,126594,567232,767850) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002643s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001108s ]