SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550911 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550911 [ RunTime:0.001917s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (385435,238773,757997,596110,72860,132809,515087,826421,977358,251708,273650,977587,500148,1015162,616972,165071,279308,19392,831187,167503,670660,976215,91159,279842,428332,698473,830178,217345,943801,499342,657888,381699,535256,342233,1035924,723944,718398,34480,3183,663410,568496,511994,299083,497952,359674,968307,386972,142422,221148,157730,54790,751278,667251,881763,982121,222801,1010993,707350,743140,991041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]