SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004765s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 369081 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 369081 [ RunTime:0.001910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454437,679939,132314,27581,778454,584438,214920,103859,692889,331887,122925,817668,178949,950506,2098,233101,525626,235240,800832,143889,1028341,48429,824374,460297,183170,50875,396094,171591,1036818,54090,421694,872039,375176,884184,624554,38709,243047,864476,260115,91011,453306,145034,342383,572830,487163,427178,488495,910551,167984,546961,704588,321409,474866,407479,578937,364477,155871,883752,499154,416790) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004652s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 369081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 369081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002663s ]