SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403263 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403263 [ RunTime:0.001546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (305913,2660,721028,577654,944129,267314,521488,1030475,708856,112062,1028567,227292,379192,574088,787613,590744,576566,239308,958727,770454,14787,353512,326991,544226,352416,727628,282609,800341,1034096,673080,104303,702843,809734,513011,492108,739253,456972,739936,724379,358001,167152,69544,451145,251357,209225,518134,222420,909298,353290,981488,512877,565263,553359,333868,518739,105883,173872,704004,934939,252071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403263 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403263 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]