SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450513 LIMIT 1 [ RunTime:0.003725s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450513 [ RunTime:0.003138s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (484745,581662,632409,996626,678349,927341,990720,495309,749880,46074,198285,616724,231072,515460,601859,106445,618930,1034674,47232,698360,810883,276481,258270,509443,692988,616267,250159,498362,162927,172068,762639,295518,488526,626335,832121,750334,925207,457041,279288,701782,466833,499829,754166,362099,984173,85765,708394,633190,456336,160336,565609,634804,82198,121225,762677,785469,914085,639989,918093,88792) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001673s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001069s ]