SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001836s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4394 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4394 [ RunTime:0.001519s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398398,70505,581514,985157,266991,379417,833883,143102,712109,346889,674574,177348,1043316,619420,324955,170954,888271,517629,1013668,913604,197608,603725,617022,505936,67246,911771,754684,85281,966862,720802,703324,234223,1032741,170427,872494,213668,218363,724469,626469,979383,133668,408518,594217,213257,603204,245819,101814,852043,202539,757122,585053,258987,270515,1021391,587024,602020,586537,582682,835490,477307) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4394 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4394 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]