SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334181 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334181 [ RunTime:0.004331s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (974742,548610,536690,924845,912538,782285,918740,817969,290679,172612,760823,26152,527196,953104,216807,659092,810766,728860,811408,220633,126371,104014,684624,377266,908383,513331,936790,750928,583870,536649,1012173,506873,993978,675280,84045,113551,987357,592924,120900,752648,568818,516759,666109,975042,279975,395695,86796,613604,53325,992055,683911,439243,38166,1024980,390692,613947,264293,237100,251196,809902) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]