SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43982 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43982 [ RunTime:0.002113s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50604,773035,678852,490778,533746,638472,188108,257381,673674,467521,290287,116499,378145,606471,991851,792538,845597,811000,994191,914084,1036241,271894,393567,965564,1016185,1003591,359458,794999,515260,634424,1042003,1023246,474904,759739,211615,57579,301257,550582,908653,714913,788854,247064,173129,492966,1045096,431673,676180,490399,970390,727710,777182,543249,769323,733106,643759,720443,7108,612077,70963,785246) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43982 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43982 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]