SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412013 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412013 [ RunTime:0.006406s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (73548,160263,51569,820700,726846,70655,1015516,654087,864176,581031,78390,65597,104882,893212,725373,655346,705468,1018630,756566,381351,230690,92429,971626,292675,289133,600751,1035005,210692,678813,833682,847451,794496,71153,646094,878282,571082,578717,114114,435135,303748,197055,702987,322157,609141,969725,423291,523202,909437,301335,717479,7742,652666,446087,770639,22413,613063,55722,493914,679257,819406) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001729s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001254s ]