SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 308029 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 308029 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518920,370721,598472,561395,931826,433858,1018710,511876,61677,720254,702740,948581,950166,703435,706153,509236,487530,482633,492539,337400,439875,1011834,525496,4152,19138,320658,884719,374189,244715,976105,1023307,730521,835604,165766,489768,418957,575598,474506,356597,782965,53038,460699,54624,231315,648996,914465,730113,905863,696440,896410,289270,1026532,328994,375391,889318,71346,518783,861755,878979,330717) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 308029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 308029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]