SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002474s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023991 LIMIT 1 [ RunTime:0.001347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023991 [ RunTime:0.001817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (852728,18827,90371,31171,19777,1010912,672094,848696,659676,817708,635147,788167,880669,560139,1019182,722009,180842,85066,283083,322358,214112,554410,256838,564853,196005,760733,456820,391537,5711,285725,606971,780889,178921,149335,554801,49218,61665,162140,423749,718131,1012218,62427,1042366,616842,376632,24968,88919,949484,407721,42792,410885,376029,676119,768225,657186,541570,993235,905417,999948,144932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]