SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502164 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502164 [ RunTime:0.001510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337521,199746,368832,314276,278462,169334,596018,873188,46606,838931,672323,648065,101953,213755,884829,869938,503696,245239,992111,236362,877991,199433,777076,502640,842216,217006,257298,215863,748383,847123,808574,836819,820827,1011884,1038723,1020947,486581,880285,592370,865380,100110,956805,825269,478253,741042,720610,781506,615803,928951,495242,461523,533973,369701,438889,780140,729358,606918,138398,392020,309363) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502164 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502164 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]