SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338343 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338343 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (992391,917026,790004,245636,976867,925672,482967,383719,500567,971541,633316,667081,574311,814152,710897,138516,632777,90860,280222,739231,946882,763850,811521,842197,521649,483203,341857,1019567,2920,872207,864855,837456,220496,355211,965337,238284,378116,752893,916195,940066,90761,549358,359244,933846,144459,165800,275591,581068,12400,459372,803144,362329,93070,295581,789743,1024846,343947,631687,901745,123510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003268s ]