SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201341 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201341 [ RunTime:0.001784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (936112,333836,961022,816502,1048808,906968,361440,14992,556117,200121,444606,554802,441378,776712,655304,487654,457976,277783,1041612,557104,392042,615523,1013545,549516,139355,744362,621581,846075,640888,475564,542069,1032569,822076,535995,823088,624148,130636,91712,253560,1017038,909754,870265,95224,706630,687260,838389,64257,931635,415547,874752,729118,323132,614620,72006,556820,1000697,619344,873687,1032691,595684) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]