SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107209 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107209 [ RunTime:0.001819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (697133,89329,517594,505065,756384,113459,241188,526405,695043,488031,435952,126230,677589,868145,229416,374089,673260,349250,822016,689165,724667,452004,647551,52389,493861,986499,840828,1044948,406951,299462,139713,86012,157730,925158,621186,499794,244628,754520,303015,278582,423478,505710,569192,412131,364420,393599,285073,96051,979014,501028,330163,389827,992564,1013053,406853,598378,132026,77974,557132,307937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]