SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193076 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193076 [ RunTime:0.001539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (126239,396861,264691,812242,988499,922452,832185,386326,74405,267146,235087,43663,203008,307471,151565,949958,894237,433544,811117,199990,212044,501054,505944,273200,797972,614465,602024,190583,388976,968237,453176,660659,290137,995645,379717,568843,790400,849811,346696,181502,423826,784455,955150,814003,122099,285718,810936,992726,146915,422374,1011083,340750,329632,182367,297548,163984,670351,47411,522215,425435) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193076 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193076 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]