SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522914 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522914 [ RunTime:0.002453s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (935031,296598,165645,314141,1035803,93982,248728,690278,669721,810012,410798,546829,419887,436884,685502,697267,693894,404802,510640,468751,988277,1006922,739230,835678,1017160,72474,756460,554479,707237,682300,389137,91349,189360,115793,901291,124457,1045363,256991,616486,278719,502393,168934,754945,37088,471823,118649,127851,997334,991279,495763,578778,84082,649590,633628,253211,791561,761844,940255,883619,621629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]