SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344968 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344968 [ RunTime:0.001612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (741940,619087,412656,458935,791771,1013335,139843,260031,917044,259249,259448,100521,988653,190204,313958,481419,1029539,238982,612943,50070,632371,243657,40442,362026,424099,913216,296305,88554,742219,854858,6177,799994,41446,660174,1002676,252470,297306,6625,813176,840979,437189,455762,328642,381257,646525,355908,1034937,47788,997096,140302,819221,649823,235029,891249,404351,963596,370033,627948,607247,510131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]