SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525749 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525749 [ RunTime:0.002311s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404210,206745,635874,65872,286136,505200,592977,963164,979260,497048,29964,388415,736957,139120,234584,929369,473810,522562,1020615,657452,568438,134222,513074,616464,789231,372092,383971,640051,467217,86956,70809,927329,138022,199576,429888,116235,770677,890705,132099,772698,683140,460555,658727,527977,633568,989519,105169,250103,297206,176636,362015,768767,190050,49590,153506,905095,1012376,990887,532684,99625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525749 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525749 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]