SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003505s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504313 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504313 [ RunTime:0.003010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (797417,494748,160618,455567,984786,526656,290940,767639,465736,340722,616553,194253,143049,524786,33097,413169,953871,916359,698862,100410,948214,400001,26496,237471,636172,402244,998219,915504,680216,268077,784843,94121,990943,280671,487026,92692,527368,634684,554502,263791,167880,651324,574616,289085,967846,908860,992293,835295,87632,60045,662291,141012,281215,472549,1029631,105292,470188,855844,504125,312309) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000663s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001485s ]