SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001429s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400093 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400093 [ RunTime:0.002192s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (376089,743322,321824,759859,765501,985644,252892,136878,319186,589895,144470,182463,806377,1015593,809994,251765,59276,144410,522702,372021,606921,229395,78636,1016281,848460,446355,804219,1043950,18472,480517,327684,635524,834895,264304,682475,333131,475681,589542,527644,63060,487538,630547,332934,797614,79702,963924,844433,914200,995599,584856,666050,295950,676744,574537,890302,732010,182747,233470,920450,508000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]