SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 191020 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 191020 [ RunTime:0.001899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (778627,766075,382559,647098,395135,909028,962956,183631,148289,32298,406525,250655,957774,503181,174292,396145,467005,436567,132699,673015,852473,65382,805516,723316,405696,818827,407408,633154,446840,805293,369900,253985,863413,238079,3022,232571,481011,440996,629875,243939,803311,5230,504394,16423,359101,275098,938229,899977,16848,535473,455640,110558,488496,425206,578699,832943,830581,1035670,255003,44392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 191020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 191020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.009475s ]