SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41311 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41311 [ RunTime:0.002293s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (713946,127752,368392,540054,776418,171520,886402,30681,165561,477150,760178,145367,401361,424017,680496,585839,372260,953546,749392,168793,743350,758302,540420,90098,387249,870705,264696,199785,704005,611112,24703,767737,2320,270556,466205,819911,824604,1043890,457493,266587,933431,999169,758833,1023841,505101,225937,928503,515696,869008,116759,903729,351163,441141,648207,987656,807177,183443,811507,266552,496191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]