SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002808s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 202016 LIMIT 1 [ RunTime:0.003722s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 202016 [ RunTime:0.002105s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (742516,36684,877670,953197,397130,60326,365332,1027745,450742,980029,898783,915879,149366,742747,470668,650950,945052,415816,609556,565786,87088,247114,995864,283519,487055,110750,707787,265070,175266,809536,301188,528396,360150,930482,566295,701561,681202,337294,1025359,20464,536777,159768,153506,643361,126219,89635,738124,383900,838013,551292,913371,36737,518149,308708,489429,441906,871640,898158,663925,577139) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 202016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 202016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]