SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001456s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 76134 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 76134 [ RunTime:0.002538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109389,281266,255032,366403,104365,201208,524362,464068,237036,452696,3479,189325,274822,496452,154982,1018716,489022,942427,931219,89673,107474,468844,817683,289921,735251,274702,485606,635770,548122,672488,930143,46085,621165,176374,777217,158972,419605,831228,821693,218832,137079,99111,501948,323170,787732,89348,433339,935173,976163,271824,489342,622485,959274,1044840,791047,430689,811662,952113,507829,326169) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 76134 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001641s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 76134 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000946s ]