SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804896 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804896 [ RunTime:0.001849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002172,679392,941254,24117,459689,123176,545144,666669,597993,173490,744046,571688,933928,928167,680409,822665,398519,544690,403347,591034,417769,71650,970387,198977,359778,706227,87156,1016316,77603,322522,874262,469413,477005,554614,1028761,230800,370608,285137,905228,690223,734612,245282,258453,532707,21466,221220,560051,275083,665335,211064,608926,172403,888966,663878,932765,167766,404437,41628,241890,301064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000557s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]