SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 982806 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 982806 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239351,327002,951140,19864,605248,289070,401340,217138,774038,14968,257282,848394,752714,742139,889360,430520,132242,630664,995544,972616,84874,977520,680727,279830,568828,371766,180109,290064,857585,44902,1001783,918875,710056,889839,72447,291867,508487,596028,457403,738564,461395,537993,9435,979034,893674,1019293,51425,508804,181925,666909,390320,445137,839368,707390,680598,758579,566900,915175,684615,272414) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 982806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 982806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002767s ]