SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 574243 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 574243 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444524,465241,954753,434328,856332,739629,300936,250322,120289,558853,567539,268074,591146,345841,131474,635828,319501,576700,522099,365539,1028196,674967,894168,936206,811976,297803,558305,817186,23123,65620,958040,752685,741945,40678,852897,300545,686665,166870,707369,541961,748408,1008283,959862,808281,200261,870122,160714,837786,86002,393540,650906,183043,64692,315367,434855,1039212,623352,879234,226701,941137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 574243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 574243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000725s ]