SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 390447 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 390447 [ RunTime:0.002367s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496408,634498,563050,1012009,778504,327278,467633,914970,944623,782410,465452,706019,399144,485133,867856,118074,550702,236625,859730,858490,438468,924368,99724,479184,608605,879044,727054,296418,206233,800382,807874,286594,672386,806808,873147,288855,7198,639519,304803,980134,29073,631165,580937,619205,632309,318888,443483,22391,424404,867339,484095,200322,687758,444205,776574,441517,384352,43360,1046366,420289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 390447 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 390447 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]