SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040272 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040272 [ RunTime:0.001590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (677272,62684,87167,759528,534577,212708,144070,789851,726674,749886,735274,336435,308342,949704,987895,912796,1015028,131707,380473,350104,986711,958145,480403,334326,707499,1010862,278585,429307,596588,998140,612511,626025,1042411,136820,479186,253090,362423,287319,32814,376058,860032,475299,327445,470012,970338,433086,702303,888920,300992,541054,340663,622360,322785,219852,574548,541427,880898,127374,231473,173514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040272 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040272 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]