SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005848s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346036 LIMIT 1 [ RunTime:0.000547s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346036 [ RunTime:0.004433s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501505,198583,470129,291448,662294,5230,934392,706755,350411,110377,929893,253425,448681,944294,805289,394696,871829,329606,58500,393315,489716,235870,935911,23710,822124,443299,988528,591995,856479,818804,353134,240378,1046885,609165,1010622,392137,459662,344141,616831,189529,533564,419218,374690,959780,754004,715513,652259,572441,897103,729001,609729,354575,420801,753151,77981,283567,455110,586050,334267,1030481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003195s ]