SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491713 LIMIT 1 [ RunTime:0.000544s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491713 [ RunTime:0.002455s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (833204,100331,383568,85313,313726,262791,921886,809806,1002045,246666,682401,126888,779507,95262,273821,192627,476169,754667,1042942,254046,190905,860784,2789,684336,289668,850095,46758,896477,379342,715083,141995,977521,131104,344178,1040796,172281,815526,339557,787530,221586,910649,991087,930162,997506,723568,60092,467048,380854,13213,344486,691961,671310,744995,618106,49337,712781,967058,306852,1048807,750430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002199s ]