SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 149899 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 149899 [ RunTime:0.002257s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503133,575620,127421,231482,839178,609332,908951,223823,911675,833996,324703,500473,541681,545537,872997,46789,484556,313463,1039517,520565,982004,344666,472449,905209,361237,108926,412252,48328,50516,263958,561449,591398,881270,84630,448150,621354,718624,46224,525929,212258,685030,285623,936703,523212,448184,917555,633965,857854,284409,633277,185547,799033,189929,217479,436950,705793,409574,153745,305866,436441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 149899 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 149899 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001458s ]