SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 900045 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 900045 [ RunTime:0.001754s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417580,453714,656117,128488,902875,23045,199583,855559,538635,911631,702500,407575,610048,341601,860595,605710,594168,710248,1012838,377375,13613,151830,1008641,546273,759648,410349,860172,964011,530895,454424,456946,364719,1047731,642395,779135,1006916,1010265,806133,889814,316399,918428,472020,206260,839022,726761,8441,308253,423958,672473,1044108,759936,288210,351766,979649,294088,903177,317000,237555,723423,929158) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 900045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 900045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000724s ]