SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 842811 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 842811 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (738394,393115,446774,841873,428510,472435,388211,283582,106822,528492,5404,204465,452885,158421,160906,885118,4152,616536,606985,409700,667471,105250,9919,881630,630557,630852,1015132,1003601,307313,901723,1002401,1017477,1039451,977546,697654,957242,532951,796079,965014,653883,1694,220367,17303,239747,740606,507314,436297,185378,146438,759018,1022596,598095,978877,814640,497977,259592,510953,61118,631993,1046706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 842811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 842811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]