SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469917 LIMIT 1 [ RunTime:0.000767s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469917 [ RunTime:0.001888s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404532,17861,98195,661960,461687,791270,899603,123810,770051,281197,598783,342044,338576,31592,1036890,378882,525083,340415,1046825,331937,582359,405818,824044,538680,828978,83225,85023,570669,651401,68835,577567,72311,883039,597659,1019203,228946,155014,785492,968157,709782,853416,990707,568665,173196,704968,770083,309451,749868,924583,706637,973889,277246,546584,453605,175792,535358,349794,938721,413108,740457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001163s ]