SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543692 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543692 [ RunTime:0.001595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469319,993503,232013,522705,458880,38428,842256,1041533,971155,591431,161729,1019231,524842,939847,26411,623575,383286,1037594,937021,741972,428014,664383,856197,424685,892443,398474,428147,631256,948761,597017,850406,771032,299588,578243,842590,457843,823764,154560,5267,223219,27523,563541,640454,61256,98752,61137,412938,392020,256958,546311,773423,16293,218557,30271,650239,119130,623652,510746,799114,151548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543692 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000629s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543692 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]