SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802502 LIMIT 1 [ RunTime:0.001995s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802502 [ RunTime:0.001621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379459,207355,578062,195591,493986,728670,735607,1010004,557921,531349,614508,738888,238690,397612,606492,745465,262154,537016,32988,772071,670210,941831,200774,235954,599733,57539,252830,808062,416862,15421,445734,962050,269121,865214,494308,40481,838562,669372,689733,973789,963131,451200,610176,1039216,481487,589324,939009,421574,126426,682520,675381,813288,472703,785784,161570,585182,462358,341271,919589,971041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802502 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802502 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]